怎么在EXCEL单元格内随机生成16位数字字母答:一、随机生成16位数字加大写字母,公式:=CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(...
能否利用excel公式,在不含大小王的一副52张扑克牌中,随机产生21张牌(含...答:输入以下公式 =CHOOSE(RANDBETWEEN(1,4),"红桃","梅花","方块","黑桃")&CHOOSE(RANDBETWEEN(1,13),2,3,4,5,6,7,8,9,10,"J","Q","K","A")公式表示:CHOOSE(RANDBETWEEN(1,4),"红桃","梅花","方块","黑桃")得到花色的随机数,CHOOSE(RANDBETWEEN(1,13),2,3,4,5,6,7,8,9,...